[ROOT]  dt  DimEmployee  <  WHERE ParentEmployeeId EQ '142'  >   

7 items

DimEmployeeId	BaseRate	BirthDate	Department	EmailAddress	EmergencyContactName	EmergencyContactPhone	EmployeeNationalIDAlternateKey	FirstName	Gender	HireDate	LastName	LoginID	MaritalStatus	MiddleName	ParentEmployeeId	PayFrequency	Phone	Photo	SalariedFlag	SickLeaveHours	StartDate	Status	Title	VacationHours
96	19	1987-09-06	Finance	candy0@adventure-works.com	Candy Spoon	920-555-0177	60517918	Candy	F	2020-07-20	Spoon	adventure-works\candy0	S	L	142	2	920-555-0177			50	2020-07-20	Current	Accounts Receivable Specialist	61
170	19	1988-08-28	Finance	dragan0@adventure-works.com	Dragan Tomic	117-555-0185	663843431	Dragan	M	2020-08-25	Tomic	adventure-works\dragan0	M	K	142	2	117-555-0185			51	2020-08-25	Current	Accounts Payable Specialist	63
61	19	1987-09-18	Finance	deborah0@adventure-works.com	Deborah Poe	602-555-0194	363923697	Deborah	F	2020-07-01	Poe	adventure-works\deborah0	M	E	142	2	602-555-0194			50	2020-07-01	Current	Accounts Receivable Specialist	60
133	19	1996-04-03	Finance	bryan1@adventure-works.com	Bryan Walton	935-555-0199	931190412	Bryan	M	2020-08-07	Walton	adventure-works\bryan1	S	A	142	2	935-555-0199			51	2020-08-07	Current	Accounts Receivable Specialist	62
182	26.4423	1987-07-18	Finance	barbara1@adventure-works.com	Barbara Moreland	822-555-0145	363910111	Barbara	F	2020-09-01	Moreland	adventure-works\barbara1	M	C	142	2	822-555-0145		1	49	2020-09-01	Current	Accountant	58
205	19	1990-09-20	Finance	janet0@adventure-works.com	Janet Sheperdigian	393-555-0186	519756660	Janet	F	2020-09-12	Sheperdigian	adventure-works\janet0	M	L	142	2	393-555-0186			52	2020-09-12	Current	Accounts Payable Specialist	64
220	26.4423	1991-01-12	Finance	mike0@adventure-works.com	Mike Seamans	927-555-0150	480951955	Mike	M	2020-09-19	Seamans	adventure-works\mike0	S	K	142	2	927-555-0150		1	49	2020-09-19	Current	Accountant	59

Generated 2026-01-11 23:14:49.310 UTC